Full File Path in Reference to Another Workbook in Excel

Posted by SHARIQ MUSANI on Super User See other posts from Super User or by SHARIQ MUSANI
Published on 2012-09-05T20:03:30Z Indexed on 2012/09/05 21:40 UTC
Read the original article Hit count: 193

Filed under:
|
|

I have two Excel files, one on D:\ and the other one on E:\.

I reference one from the other, for example, using vlookup in the E: file to search from the D: file, like that:

VLOOKUP(A1,'D:\SHARIQ\[FILE NAME.XLS]SHEETNAME'!A1:10,3,FALSE)

As long as D:\SHARIQ\FILE NAME.XLS is open, I get the formula in the E: file displayed like this:

VLOOKUP(A1,'[FILE NAME.XLS]SHEETNAME'!A1:10,3,FALSE)

Why does it remove the whole path?

© Super User or respective owner

Related posts about Windows

Related posts about microsoft-excel